UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UDIK/G+N4bzge/9MHqmA7LLl8rFO1pnYB6Ed+UAOoqo=' 
WHERE 
  key_id = 'c8c5fb9bb0212893a1a04e6092841151e02d6312669c57971b656001405965f0' 
  AND (
    token = 'UDIK/G+N4bzge/9MHqmA7LLl8rFO1pnYB6Ed+UAOoqo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034