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