UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nzbDTGVFjwlojxscgWZYhxBrxa32sAhMj9Z6VnI1Vs4=' 
WHERE 
  key_id = '361d78b10b8134c3baa1073c41983edf079cc75bef11a6ea8ae7e174abd25f7f' 
  AND (
    token = 'nzbDTGVFjwlojxscgWZYhxBrxa32sAhMj9Z6VnI1Vs4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026