UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'knfZ5P/odq/vOt9/rayT2jTe8qx7cAuA9xxqOUC/BJk='
WHERE
key_id = '7c24d292557c88d88ecf90e5ff6985220c74b7e067462f9cb79d64eb1b939354'
AND (
token = 'knfZ5P/odq/vOt9/rayT2jTe8qx7cAuA9xxqOUC/BJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)