UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UrDjldptTE1P7iLAjsVB9XH8DVgWyr91m4MlRC9BVuM='
WHERE
key_id = '82e8e4c442ba391086b3941a2fca5cae0afc8b2a369fe5678b6aa5718cf399a0'
AND (
token = 'UrDjldptTE1P7iLAjsVB9XH8DVgWyr91m4MlRC9BVuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)