UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '77XWL5+ZPvfStC1VmZip85gq0F+G1YBXwAnt5CHchhI=' 
WHERE 
  key_id = '2cf2e1d4ba5c5dc21c17c7922d15f8c9849a77422d01f2ee3bd70130b0f8ed58' 
  AND (
    token = '77XWL5+ZPvfStC1VmZip85gq0F+G1YBXwAnt5CHchhI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032