UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JJBkd49EQdb+mh5kr0jIfxKfeSbpFfDD+xGC1MgJgB8='
WHERE
key_id = 'efdcd417c65437c51df2347cf33f39b18ef1c8f2db9d3e246045df05a18608ce'
AND (
token = 'JJBkd49EQdb+mh5kr0jIfxKfeSbpFfDD+xGC1MgJgB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)