UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjBfG0x+jgpzPf/sFoWWaaEz2iq0vW4zk1vuLFIgRxU='
WHERE
key_id = '34927c3e9c7c8d62e1f19b9084fb7233068559214d591aee0f6b28fc68132a4a'
AND (
token = 'XjBfG0x+jgpzPf/sFoWWaaEz2iq0vW4zk1vuLFIgRxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)