UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCHXiVDza4DDrmT0pkI6kxNf0V6yYjE+af9bbVYdPD8='
WHERE
key_id = '00cab9a276e7ba27e916454c914ac31aa159eaceacda5ce9beff31b0b34ffeab'
AND (
token = 'NCHXiVDza4DDrmT0pkI6kxNf0V6yYjE+af9bbVYdPD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)