UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuL4cc5/vFN2qgcTCVEpBobSyDkehjJTMT9JbH4v20M='
WHERE
key_id = '9653ce834e4550edc194c338c5b587a52713ff14f6688c6c280b53f885da42d0'
AND (
token = 'XuL4cc5/vFN2qgcTCVEpBobSyDkehjJTMT9JbH4v20M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)