UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2qGOA1qnecGdAhxNKjwxQ0mZyw2SvtigjpSoOkU+y5Y='
WHERE
key_id = '1a165f2b4fb4741fdaed5d957440d7c1b5d73017240c1bc0fe04c50592e95eba'
AND (
token = '2qGOA1qnecGdAhxNKjwxQ0mZyw2SvtigjpSoOkU+y5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)