UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKRfAjAa4U4qpmIj1C8qJLL/OFYthxt+iPowZPv/UvU='
WHERE
key_id = '3d7eadaa0d94a2597ba7a7ebc526bf4005f030dc27a0d72e0daa348b125bf693'
AND (
token = 'XKRfAjAa4U4qpmIj1C8qJLL/OFYthxt+iPowZPv/UvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)