UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCFh93QpLxnoALbomOrZEFmDsBK3KeYNSLsGAVQwFMU='
WHERE
key_id = '3e87abe71b95f74fb902610cb99d81a1e902a4499198b1739b8ea14b18f223bd'
AND (
token = 'YCFh93QpLxnoALbomOrZEFmDsBK3KeYNSLsGAVQwFMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)