UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9D96YdAc0SKmhaxPILikBrBiWf8LnAU4MHj8Ntu4tlE='
WHERE
key_id = 'a15dc3d06151403fa57cc7fe427fcbfc7fedc963d2a3d0311b2f4ce2d95cf95f'
AND (
token = '9D96YdAc0SKmhaxPILikBrBiWf8LnAU4MHj8Ntu4tlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)