UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'F4OAGN3zWf3vpjE9SlXBF3FZXLbyVHoBwHb5/HQqVzU=' 
WHERE 
  key_id = 'b5df3afea4f435806170f934f14edfa2091d5a9ff5b1646614f4172b038b0234' 
  AND (
    token = 'F4OAGN3zWf3vpjE9SlXBF3FZXLbyVHoBwHb5/HQqVzU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029