UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7Im+H/LWtO7YHezFklbnI0lE6la0Kpaa5X2TrDNcmo='
WHERE
key_id = 'f647ca74cf1d2f40129f35da9e08b62d90cc2b43f59543c40d0be1451ecdaaa0'
AND (
token = 'q7Im+H/LWtO7YHezFklbnI0lE6la0Kpaa5X2TrDNcmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)