UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZI0Pq82wxtuYLufn+9WMvYLf7/AU00tep+KJ3hmQSAE=' 
WHERE 
  key_id = '1d69d5a26ab7f1c690e33afaf5aabc17c6d44efe6b1180be76f1ccc6412cf5bd' 
  AND (
    token = 'ZI0Pq82wxtuYLufn+9WMvYLf7/AU00tep+KJ3hmQSAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037