UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBdLQYD8v1m+gBoB6E9jYm+JBq3sH/eJmYOo1siFZcU='
WHERE
key_id = '7e8f0d2a1781fa879dc7919024f1b08691190af1aee08f58a642fb18bfb45947'
AND (
token = 'TBdLQYD8v1m+gBoB6E9jYm+JBq3sH/eJmYOo1siFZcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)