UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qodPpfnO49betaNrWCJjCiSGIxy9+krQbvm1H+Zmlk4='
WHERE
key_id = '0e16e847e71de27546a6de0e6cc6f4556b10dfb553e6dda16c5658dd23e7cfc0'
AND (
token = 'qodPpfnO49betaNrWCJjCiSGIxy9+krQbvm1H+Zmlk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)