UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKtB8/WQRqCfnrpMT7MAuAgdQEYC+fxiT9/i9accjAU='
WHERE
key_id = '05b7f95dc6b3cbc4137e5be7e7d57f18963bf0ec27d91aa9390d41d5af82ab6f'
AND (
token = 'cKtB8/WQRqCfnrpMT7MAuAgdQEYC+fxiT9/i9accjAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)