UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzL9QaJU4L3T3Qo14INDv5tlKZHEYXaEq4vd8oXary8='
WHERE
key_id = '7a100b279f73592884aa7c4468e38e3ef1cfe70d036968f96adc8b021432ce65'
AND (
token = 'XzL9QaJU4L3T3Qo14INDv5tlKZHEYXaEq4vd8oXary8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)