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