UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Txgzshn4JCa2vsGVzRnTVlPkVBc/QMsvPpDo8sJlrRg='
WHERE
key_id = '0e1197393b3bbe01e5af358c036902d70845b07993fd66d16eb52ebb3ba21fa2'
AND (
token = 'Txgzshn4JCa2vsGVzRnTVlPkVBc/QMsvPpDo8sJlrRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)