UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fBzn1vM8j/t0lH+OeOi8OQVmznsCGEZfLVdVY41YftI=' 
WHERE 
  key_id = '924355d399af1fbb2903bec3db58e75b66c36f747fbbfde6fc1b924ddc3e5357' 
  AND (
    token = 'fBzn1vM8j/t0lH+OeOi8OQVmznsCGEZfLVdVY41YftI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032