UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CItB3LAN4tTHBkIscBcv9K4OtPNGN9JuHPeRR+/xmbE='
WHERE
key_id = '89c9a916d6ef96e42d6a5db9aa36a1f9bf3b39504db531b6e6ec81e69f346cd2'
AND (
token = 'CItB3LAN4tTHBkIscBcv9K4OtPNGN9JuHPeRR+/xmbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)