UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bin+J9qzVkZagDlJIIxX12YMIMgbOPSMxBquBjBGpLo='
WHERE
key_id = '806a7badaa8fb14e0f22d748f774e76373ab77db15b97dcf9a27e7b3fad1f6f2'
AND (
token = 'Bin+J9qzVkZagDlJIIxX12YMIMgbOPSMxBquBjBGpLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)