UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pty8NT1XbSWjAWFs3f+vvhqK2ID32tvC7WoppLgYQNw='
WHERE
key_id = 'a6d6a527b8aa91cb7201cadc66a56c4ce66cbc586765a9e912faa5d3eb81ed52'
AND (
token = 'pty8NT1XbSWjAWFs3f+vvhqK2ID32tvC7WoppLgYQNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)