UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4ozsh/ShocMNnG1fnI/PMY/5hkEF8AEU2Y2D27zJW0M=' 
WHERE 
  key_id = 'b69e51af6a2c9b66e587706c7e68f90d5ba360a79177aeb4cdba4cbb37535a68' 
  AND (
    token = '4ozsh/ShocMNnG1fnI/PMY/5hkEF8AEU2Y2D27zJW0M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028