UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g0q15X+A7M86YZsUxFqSH3sirn51hisiF6/6z4D/eAs='
WHERE
key_id = 'b99837485d73c8960d954e7e832457ff4c5bd420c5771aa913684b0232e4834e'
AND (
token = 'g0q15X+A7M86YZsUxFqSH3sirn51hisiF6/6z4D/eAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)