UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpaM/QejzIcmVcp7X5rK4cKG2hB97QkWu7rynDHA6Hk='
WHERE
key_id = 'd1642645cad5886a04eb58f0cd522b80587112987f43ba5bcdd7a8e54cdb5a76'
AND (
token = 'tpaM/QejzIcmVcp7X5rK4cKG2hB97QkWu7rynDHA6Hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)