UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6WvO1fSqA2HkUukd7ArRiy8ZaX0pwtUDUFM5EZ47Ug='
WHERE
key_id = '7431da79def754c50df5a23b675d3b4a42dc8ec011e6d348cd1c6014fe33b7a9'
AND (
token = '+6WvO1fSqA2HkUukd7ArRiy8ZaX0pwtUDUFM5EZ47Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)