UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1Vv1IsVfL1wd7HfzUj46E3+GqW+rQKueh/91t+sAfEg=' 
WHERE 
  key_id = 'a4a889464a5f0ec49a5ed364d7b7fa3a8d7f080cb8fb097ba5244eeed2e4d398' 
  AND (
    token = '1Vv1IsVfL1wd7HfzUj46E3+GqW+rQKueh/91t+sAfEg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031