UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUPcNHqbJBrf4+kS7AasqQpH9Qvh1JxjZOTpzWh0peg='
WHERE
key_id = '4bddf629ef67ffa3737fe142c44ada47943476b3853abe1fa3a436094130c163'
AND (
token = 'TUPcNHqbJBrf4+kS7AasqQpH9Qvh1JxjZOTpzWh0peg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)