UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZ8xBCZiQ4ZZ7MTZsIcjUxZKen7zwfVEnaLlf1sFh7c='
WHERE
key_id = 'ef2fccedf4beebe84128f7106a50fa539a58fa5b2db1615b1c213f0a4bb28fc3'
AND (
token = 'qZ8xBCZiQ4ZZ7MTZsIcjUxZKen7zwfVEnaLlf1sFh7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)