UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mTMrWt+NsffS8uZ7IzGP+6JLyGOm90GqgnIBNfnIl4g='
WHERE
key_id = 'caf0fa0d8e456463ec55653802d647e1b0d445ab38a8670d4c296b2408483db1'
AND (
token = 'mTMrWt+NsffS8uZ7IzGP+6JLyGOm90GqgnIBNfnIl4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)