UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bVVJRPNr2s3CUmRLKzYS2RMwmt7sZQdwyybv1E/hbjU='
WHERE
key_id = '1d1955206cd70b8611a7e66960e91e6d7d79129e83bdae18a9258a55b44a5842'
AND (
token = 'bVVJRPNr2s3CUmRLKzYS2RMwmt7sZQdwyybv1E/hbjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)