UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EDVVFMF0lvmH9Lqb4Mvu3o7eyi68bZDd4kDIFoMj0ZU=' 
WHERE 
  key_id = 'c94f5dc628c3acd1ceb038db327cab27d716300c7dce6c254221a26376cfe232' 
  AND (
    token = 'EDVVFMF0lvmH9Lqb4Mvu3o7eyi68bZDd4kDIFoMj0ZU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035