UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qlemntlusP+rPVCykywVyboh5fFNGqryccWUZO0ysw='
WHERE
key_id = 'b847c56a0c22b433be2e9db04fec0f7cff686964f9ab967af6cc1908bcd817fc'
AND (
token = '9qlemntlusP+rPVCykywVyboh5fFNGqryccWUZO0ysw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)