UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gi8QwkJ8BJOPHEdPAX5qLQVP1eNit7HUaVIKxmTuoHE='
WHERE
key_id = '1b1023aad90700c0afe5e8aa1599f14f2b8f3f0f962a8cc04e5c95cc3387f4d6'
AND (
token = 'gi8QwkJ8BJOPHEdPAX5qLQVP1eNit7HUaVIKxmTuoHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)