UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rd1UoJPHkBzuW3iAvL/aKuk86VIPWaclD37vLSPG3tU='
WHERE
key_id = '342bb28c64e745dd74145983b9a867186a818d934185b4b5f77530918a49b454'
AND (
token = 'rd1UoJPHkBzuW3iAvL/aKuk86VIPWaclD37vLSPG3tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)