UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SQpQnr14uXQ/cqqiLKDHFj4/1ebTVTC7BC/VOcoPX3c='
WHERE
key_id = '9ac2f70810a47eca1f42579add7060a03afce910c809eb022467273e23e3e4a3'
AND (
token = 'SQpQnr14uXQ/cqqiLKDHFj4/1ebTVTC7BC/VOcoPX3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)